BEGIN TRANSACTION GO ALTER TABLE dbo.gen_Appconfig ADD BankAccount int NULL GO COMMIT BEGIN TRANSACTION GO UPDATE dbo.gen_Appconfig SET BankAccount = 120000 GO COMMIT BEGIN TRANSACTION GO ALTER TABLE dbo.Voucher ADD BankId int NULL GO COMMIT